Joomla! 1.5x Customization by Daniel Chapman

Author:Daniel Chapman
Language: eng
Format: mobi, epub
Publisher: Packt Publishing

This will leave us with a query that looks something like this:

SELECT u.username as name, u.id as userid, count(jp.id) as total FROM jos_joobb_posts jp LEFT JOIN jos_users u ON jp.id_user = u.id GROUP BY u.id ORDER BY total DESC

If we put this query into Easy SQL, we should get exactly the output we are after. However, there may be an unnamed record in your list. This is because Joo!BB can allow guests to post (depending on your settings) in the forum, and it is very likely that if we allow guests, then guest will always be our top user. This is because all guests posts will be added together.

So to get around this, we will add a WHERE clause into our SQL to ignore the guest posts.

SELECT u.username as name, u.id as userid, count(jp.id) as total FROM jos_joobb_posts jp LEFT JOIN jos_users u ON jp.id_user = u.id WHERE jp.id_user > 0 GROUP BY u.id ORDER BY total DESC

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.